Profiling Report

Dataset statistics

Number of variables	17
Number of observations	35064
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.4 MiB
Average record size in memory	311.3 B

Variable types

DateTime	1
Numeric	11
Categorical	5

Alerts

`clouds_all` is highly overall correlated with `weather_description` and 1 other fields	High correlation
`humidity` is highly overall correlated with `temp` and 2 other fields	High correlation
`rain_1h` is highly overall correlated with `weather_description` and 3 other fields	High correlation
`temp` is highly overall correlated with `humidity` and 2 other fields	High correlation
`temp_max` is highly overall correlated with `humidity` and 2 other fields	High correlation
`temp_min` is highly overall correlated with `humidity` and 2 other fields	High correlation
`weather_description` is highly overall correlated with `clouds_all` and 4 other fields	High correlation
`weather_icon` is highly overall correlated with `clouds_all` and 4 other fields	High correlation
`weather_id` is highly overall correlated with `rain_1h` and 3 other fields	High correlation
`weather_main` is highly overall correlated with `rain_1h` and 3 other fields	High correlation
`rain_1h` is highly imbalanced (76.6%)	Imbalance
`snow_3h` is highly imbalanced (> 99.9%)	Imbalance
`weather_main` is highly imbalanced (51.1%)	Imbalance
`weather_description` is highly imbalanced (54.7%)	Imbalance
`rain_3h` is highly skewed (γ1 = 25.71845945)	Skewed
`time` has 1461 (4.2%) zeros	Zeros
`wind_speed` has 2587 (7.4%) zeros	Zeros
`wind_deg` has 4439 (12.7%) zeros	Zeros
`rain_3h` has 34889 (99.5%) zeros	Zeros
`clouds_all` has 20026 (57.1%) zeros	Zeros

Reproduction

Analysis started	2024-09-11 14:31:45.041075
Analysis finished	2024-09-11 14:31:59.593439
Duration	14.55 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

date
Date

Distinct	1462
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	547.9 KiB

Minimum	2014-12-31 00:00:00
Maximum	2018-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

time
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	1461
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9222853
Coefficient of variation (CV)	0.60193785
Kurtosis	-1.2041745
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	403236
Variance	47.918033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
23	1461	4.2%
0	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
14	1461	4.2%
Other values (14)	20454	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1461	4.2%
1	1461	4.2%
2	1461	4.2%
3	1461	4.2%
4	1461	4.2%
5	1461	4.2%
6	1461	4.2%
7	1461	4.2%
8	1461	4.2%
9	1461	4.2%

Value	Count	Frequency (%)
23	1461	4.2%
22	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
14	1461	4.2%

temp
Real number (ℝ)

HIGH CORRELATION

Distinct	7272
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	288.27713

Minimum	264.132
Maximum	313.33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	264.132
5-th percentile	274.65
Q1	281.15
median	286.93
Q3	294.95
95-th percentile	305.15
Maximum	313.33
Range	49.198
Interquartile range (IQR)	13.8

Descriptive statistics

Standard deviation	9.3269934
Coefficient of variation (CV)	0.032354261
Kurtosis	-0.61872032
Mean	288.27713
Median Absolute Deviation (MAD)	6.63
Skewness	0.32550945
Sum	10108149
Variance	86.992806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
281.15	262	0.7%
283.15	233	0.7%
280.15	214	0.6%
282.15	207	0.6%
278.15	187	0.5%
285.15	183	0.5%
284.15	183	0.5%
286.15	180	0.5%
287.15	171	0.5%
279.15	168	0.5%
Other values (7262)	33076	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
264.132	1	< 0.1%
264.428	2	< 0.1%
265.091	2	< 0.1%
265.261	3	< 0.1%
265.442	3	< 0.1%
265.6245	1	< 0.1%
265.638	1	< 0.1%
265.902	3	< 0.1%
266.0235	1	< 0.1%
266.024	3	< 0.1%

Value	Count	Frequency (%)
313.33	1	< 0.1%
313.14	1	< 0.1%
312.94	2	< 0.1%
312.93	1	< 0.1%
312.8	1	< 0.1%
312.76	1	< 0.1%
312.74	1	< 0.1%
312.72	1	< 0.1%
312.54	1	< 0.1%
312.38	1	< 0.1%

temp_min
Real number (ℝ)

HIGH CORRELATION

Distinct	4370
Distinct (%)	12.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	287.05183

Minimum	264.132
Maximum	312.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	264.132
5-th percentile	273.15
Q1	280.15
median	286.14
Q3	293.71
95-th percentile	303.15
Maximum	312.15
Range	48.018
Interquartile range (IQR)	13.56

Descriptive statistics

Standard deviation	9.1787528
Coefficient of variation (CV)	0.031975942
Kurtosis	-0.66599967
Mean	287.05183
Median Absolute Deviation (MAD)	6.99
Skewness	0.29660208
Sum	10065186
Variance	84.249504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
281.15	1087	3.1%
280.15	1084	3.1%
283.15	1056	3.0%
279.15	1005	2.9%
282.15	970	2.8%
278.15	950	2.7%
273.15	920	2.6%
284.15	872	2.5%
293.15	870	2.5%
285.15	829	2.4%
Other values (4360)	25421	72.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
264.132	1	< 0.1%
264.428	2	< 0.1%
265.091	2	< 0.1%
265.261	3	< 0.1%
265.442	3	< 0.1%
265.6245	1	< 0.1%
265.638	1	< 0.1%
265.902	3	< 0.1%
266.0235	1	< 0.1%
266.024	3	< 0.1%

Value	Count	Frequency (%)
312.15	2	< 0.1%
311.15	4	< 0.1%
310.859	3	< 0.1%
310.75	1	< 0.1%
310.725	3	< 0.1%
310.65	1	< 0.1%
310.25	1	< 0.1%
310.15	35	0.1%
309.95	2	< 0.1%
309.85	1	< 0.1%

temp_max
Real number (ℝ)

HIGH CORRELATION

Distinct	4420
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	289.37196

Minimum	264.132
Maximum	316.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	264.132
5-th percentile	275.15
Q1	282.15
median	288.15
Q3	296.15
95-th percentile	307.15
Maximum	316.48
Range	52.348
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	9.6819398
Coefficient of variation (CV)	0.033458458
Kurtosis	-0.636581
Mean	289.37196
Median Absolute Deviation (MAD)	7
Skewness	0.32461809
Sum	10146539
Variance	93.739958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
283.15	1111	3.2%
285.15	1100	3.1%
284.15	1083	3.1%
282.15	1043	3.0%
286.15	1018	2.9%
281.15	1014	2.9%
287.15	964	2.7%
288.15	861	2.5%
280.15	851	2.4%
293.15	769	2.2%
Other values (4410)	25250	72.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
264.132	1	< 0.1%
264.428	2	< 0.1%
265.091	2	< 0.1%
265.261	3	< 0.1%
265.442	3	< 0.1%
265.6245	1	< 0.1%
265.638	1	< 0.1%
265.902	3	< 0.1%
266.0235	1	< 0.1%
266.024	3	< 0.1%

Value	Count	Frequency (%)
316.48	2	< 0.1%
315.37	1	< 0.1%
315.15	1	< 0.1%
314.82	2	< 0.1%
314.75	1	< 0.1%
314.65	1	< 0.1%
314.55	1	< 0.1%
314.25	2	< 0.1%
314.15	9	< 0.1%
313.71	1	< 0.1%

pressure
Real number (ℝ)

Distinct	115
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1011.7811

Minimum	927
Maximum	1042
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	927
5-th percentile	957
Q1	1013
median	1017
Q3	1022
95-th percentile	1030
Maximum	1042
Range	115
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	20.239961
Coefficient of variation (CV)	0.020004288
Kurtosis	3.7928449
Mean	1011.7811
Median Absolute Deviation (MAD)	5
Skewness	-2.1619359
Sum	35477093
Variance	409.65602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1018	2424	6.9%
1017	2330	6.6%
1019	2229	6.4%
1016	2203	6.3%
1020	2022	5.8%
1015	1912	5.5%
1021	1656	4.7%
1014	1493	4.3%
1022	1452	4.1%
1023	1262	3.6%
Other values (105)	16081	45.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
927	1	< 0.1%
928	12	< 0.1%
929	4	< 0.1%
930	6	< 0.1%
931	8	< 0.1%
932	6	< 0.1%
933	14	< 0.1%
934	20	0.1%
935	11	< 0.1%
936	13	< 0.1%

Value	Count	Frequency (%)
1042	2	< 0.1%
1040	1	< 0.1%
1039	2	< 0.1%
1038	6	< 0.1%
1037	44	0.1%
1036	72	0.2%
1035	113	0.3%
1034	182	0.5%
1033	288	0.8%
1032	322	0.9%

humidity
Real number (ℝ)

HIGH CORRELATION

Distinct	96
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.725331

Minimum	0
Maximum	100
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	19
Q1	38
median	59
Q3	81
95-th percentile	96
Maximum	100
Range	100
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	24.883323
Coefficient of variation (CV)	0.42372384
Kurtosis	-1.1542359
Mean	58.725331
Median Absolute Deviation (MAD)	22
Skewness	-0.061099075
Sum	2059145
Variance	619.17975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93	2006	5.7%
100	1480	4.2%
87	1459	4.2%
81	977	2.8%
76	723	2.1%
71	633	1.8%
86	585	1.7%
66	575	1.6%
62	559	1.6%
82	516	1.5%
Other values (86)	25551	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
6	3	< 0.1%
7	8	< 0.1%
8	17	< 0.1%
9	34	0.1%
10	52	0.1%
11	89	0.3%
12	78	0.2%
13	149	0.4%
14	191	0.5%

Value	Count	Frequency (%)
100	1480	4.2%
99	65	0.2%
98	76	0.2%
97	104	0.3%
96	173	0.5%
95	104	0.3%
94	144	0.4%
93	2006	5.7%
92	211	0.6%
91	132	0.4%

wind_speed
Real number (ℝ)

ZEROS

Distinct	18
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4338068

Minimum	0
Maximum	18
Zeros	2587
Zeros (%)	7.4%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	6
Maximum	18
Range	18
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.9730405
Coefficient of variation (CV)	0.81068085
Kurtosis	2.3174967
Mean	2.4338068
Median Absolute Deviation (MAD)	1
Skewness	1.4113511
Sum	85339
Variance	3.892889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
1	12052	34.4%
2	7751	22.1%
3	4483	12.8%
4	3004	8.6%
0	2587	7.4%
5	2151	6.1%
6	1331	3.8%
7	825	2.4%
8	451	1.3%
9	251	0.7%
Other values (8)	178	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2587	7.4%
1	12052	34.4%
2	7751	22.1%
3	4483	12.8%
4	3004	8.6%
5	2151	6.1%
6	1331	3.8%
7	825	2.4%
8	451	1.3%
9	251	0.7%

Value	Count	Frequency (%)
18	1	< 0.1%
17	2	< 0.1%
15	3	< 0.1%
14	4	< 0.1%
13	6	< 0.1%
12	18	0.1%
11	50	0.1%
10	94	0.3%
9	251	0.7%
8	451	1.3%

wind_deg
Real number (ℝ)

ZEROS

Distinct	361
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	173.36391

Minimum	0
Maximum	360
Zeros	4439
Zeros (%)	12.7%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	50
median	190
Q3	270
95-th percentile	356.85
Maximum	360
Range	360
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	121.94544
Coefficient of variation (CV)	0.70340732
Kurtosis	-1.3247779
Mean	173.36391
Median Absolute Deviation (MAD)	111
Skewness	-0.030548285
Sum	6078832
Variance	14870.69
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4439	12.7%
360	1721	4.9%
350	1646	4.7%
340	1238	3.5%
220	1074	3.1%
230	1054	3.0%
10	1014	2.9%
240	934	2.7%
210	850	2.4%
330	750	2.1%
Other values (351)	20344	58.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4439	12.7%
1	13	< 0.1%
2	12	< 0.1%
3	14	< 0.1%
4	20	0.1%
5	27	0.1%
6	25	0.1%
7	24	0.1%
8	18	0.1%
9	23	0.1%

Value	Count	Frequency (%)
360	1721	4.9%
359	10	< 0.1%
358	8	< 0.1%
357	15	< 0.1%
356	12	< 0.1%
355	34	0.1%
354	5	< 0.1%
353	28	0.1%
352	9	< 0.1%
351	11	< 0.1%

rain_1h
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.3 MiB

0.0	32407
0.3	1665
0.9	932
3.0	60

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	105192
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	32407	92.4%
0.3	1665	4.7%
0.9	932	2.7%
3.0	60	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	32407	92.4%
0.3	1665	4.7%
0.9	932	2.7%
3.0	60	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	67471	64.1%
.	35064	33.3%
3	1725	1.6%
9	932	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	105192	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	67471	64.1%
.	35064	33.3%
3	1725	1.6%
9	932	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	105192	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	67471	64.1%
.	35064	33.3%
3	1725	1.6%
9	932	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	105192	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	67471	64.1%
.	35064	33.3%
3	1725	1.6%
9	932	0.9%

rain_3h
Real number (ℝ)

SKEWED ZEROS

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00013295688

Minimum	0
Maximum	0.1
Zeros	34889
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0.1
Range	0.1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0025906774
Coefficient of variation (CV)	19.485095
Kurtosis	751.72144
Mean	0.00013295688
Median Absolute Deviation (MAD)	0
Skewness	25.718459
Sum	4.662
Variance	6.7116092 × 10^-6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	34889	99.5%
0.015	22	0.1%
0.005	18	0.1%
0.01	16	< 0.1%
0.012	10	< 0.1%
0.025	8	< 0.1%
0.05	6	< 0.1%
0.0025	6	< 0.1%
0.03	6	< 0.1%
0.037	6	< 0.1%
Other values (28)	77	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34889	99.5%
0.002	6	< 0.1%
0.0025	6	< 0.1%
0.003	5	< 0.1%
0.005	18	0.1%
0.006	4	< 0.1%
0.0075	3	< 0.1%
0.008	3	< 0.1%
0.01	16	< 0.1%
0.0105	2	< 0.1%

Value	Count	Frequency (%)
0.1	2	< 0.1%
0.095	2	< 0.1%
0.09	1	< 0.1%
0.087	3	< 0.1%
0.085	4	< 0.1%
0.08	2	< 0.1%
0.075	1	< 0.1%
0.067	2	< 0.1%
0.065	4	< 0.1%
0.055	4	< 0.1%

snow_3h
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.3 MiB

0.0	35063
1.0490000000000002	1

Length

Max length	18
Median length	3
Mean length	3.0004278
Min length	3

Characters and Unicode

Total characters	105207
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	35063	> 99.9%
1.0490000000000002	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	35063	> 99.9%
1.0490000000000002	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	70139	66.7%
.	35064	33.3%
1	1	< 0.1%
4	1	< 0.1%
9	1	< 0.1%
2	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	105207	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	70139	66.7%
.	35064	33.3%
1	1	< 0.1%
4	1	< 0.1%
9	1	< 0.1%
2	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	105207	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	70139	66.7%
.	35064	33.3%
1	1	< 0.1%
4	1	< 0.1%
9	1	< 0.1%
2	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	105207	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	70139	66.7%
.	35064	33.3%
1	1	< 0.1%
4	1	< 0.1%
9	1	< 0.1%
2	1	< 0.1%

clouds_all
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	88
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.661334

Minimum	0
Maximum	100
Zeros	20026
Zeros (%)	57.1%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	40
95-th percentile	80
Maximum	100
Range	100
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	29.656482
Coefficient of variation (CV)	1.4353615
Kurtosis	-0.054374422
Mean	20.661334
Median Absolute Deviation (MAD)	0
Skewness	1.192667
Sum	724469
Variance	879.50693
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20026	57.1%
20	3998	11.4%
75	3559	10.2%
40	2738	7.8%
90	926	2.6%
92	431	1.2%
8	270	0.8%
12	221	0.6%
24	190	0.5%
32	176	0.5%
Other values (78)	2529	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20026	57.1%
2	26	0.1%
3	2	< 0.1%
4	80	0.2%
5	26	0.1%
6	50	0.1%
7	1	< 0.1%
8	270	0.8%
9	4	< 0.1%
10	101	0.3%

Value	Count	Frequency (%)
100	26	0.1%
96	1	< 0.1%
95	2	< 0.1%
92	431	1.2%
91	10	< 0.1%
90	926	2.6%
89	8	< 0.1%
88	153	0.4%
87	3	< 0.1%
86	12	< 0.1%

weather_id
Real number (ℝ)

HIGH CORRELATION

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	769.42086

Minimum	200
Maximum	804
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	547.9 KiB

Quantile statistics

Minimum	200
5-th percentile	500
Q1	800
median	800
Q3	801
95-th percentile	803
Maximum	804
Range	604
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	98.393706
Coefficient of variation (CV)	0.12788022
Kurtosis	11.237701
Mean	769.42086
Median Absolute Deviation (MAD)	0
Skewness	-3.3794313
Sum	26978973
Variance	9681.3214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
800	20352	58.0%
801	4208	12.0%
802	3054	8.7%
803	2888	8.2%
500	1356	3.9%
701	615	1.8%
501	592	1.7%
804	493	1.4%
741	466	1.3%
300	299	0.9%
Other values (18)	741	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200	4	< 0.1%
201	7	< 0.1%
202	1	< 0.1%
211	152	0.4%
300	299	0.9%
301	82	0.2%
302	2	< 0.1%
310	2	< 0.1%
311	2	< 0.1%
500	1356	3.9%

Value	Count	Frequency (%)
804	493	1.4%
803	2888	8.2%
802	3054	8.7%
801	4208	12.0%
800	20352	58.0%
741	466	1.3%
721	16	< 0.1%
701	615	1.8%
616	2	< 0.1%
615	7	< 0.1%

weather_main
Categorical

HIGH CORRELATION IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.3 MiB

clear	20352
clouds	10643
rain	2381
mist	615
fog	466
Other values (4)	607

Length

Max length	12
Median length	5
Mean length	5.2447239
Min length	3

Characters and Unicode

Total characters	183901
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	clear
2nd row	clear
3rd row	clear
4th row	clear
5th row	clear

Common Values

Value	Count	Frequency (%)
clear	20352	58.0%
clouds	10643	30.4%
rain	2381	6.8%
mist	615	1.8%
fog	466	1.3%
drizzle	387	1.1%
thunderstorm	164	0.5%
snow	40	0.1%
haze	16	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
clear	20352	58.0%
clouds	10643	30.4%
rain	2381	6.8%
mist	615	1.8%
fog	466	1.3%
drizzle	387	1.1%
thunderstorm	164	0.5%
snow	40	0.1%
haze	16	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
l	31382	17.1%
c	30995	16.9%
r	23448	12.8%
a	22749	12.4%
e	20919	11.4%
s	11462	6.2%
o	11313	6.2%
d	11194	6.1%
u	10807	5.9%
i	3383	1.8%
Other values (8)	6249	3.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	183901	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	31382	17.1%
c	30995	16.9%
r	23448	12.8%
a	22749	12.4%
e	20919	11.4%
s	11462	6.2%
o	11313	6.2%
d	11194	6.1%
u	10807	5.9%
i	3383	1.8%
Other values (8)	6249	3.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	183901	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	31382	17.1%
c	30995	16.9%
r	23448	12.8%
a	22749	12.4%
e	20919	11.4%
s	11462	6.2%
o	11313	6.2%
d	11194	6.1%
u	10807	5.9%
i	3383	1.8%
Other values (8)	6249	3.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	183901	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	31382	17.1%
c	30995	16.9%
r	23448	12.8%
a	22749	12.4%
e	20919	11.4%
s	11462	6.2%
o	11313	6.2%
d	11194	6.1%
u	10807	5.9%
i	3383	1.8%
Other values (8)	6249	3.4%

weather_description
Categorical

HIGH CORRELATION IMBALANCE

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

sky is clear	20352
few clouds	4208
scattered clouds	3054
broken clouds	2888
light rain	1356
Other values (25)	3206

Length

Max length	28
Median length	12
Mean length	12.132586
Min length	3

Characters and Unicode

Total characters	425417
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	sky is clear
2nd row	sky is clear
3rd row	sky is clear
4th row	sky is clear
5th row	sky is clear

Common Values

Value	Count	Frequency (%)
sky is clear	20352	58.0%
few clouds	4208	12.0%
scattered clouds	3054	8.7%
broken clouds	2888	8.2%
light rain	1356	3.9%
mist	615	1.8%
moderate rain	592	1.7%
overcast clouds	493	1.4%
fog	466	1.3%
light intensity drizzle	299	0.9%
Other values (20)	741	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sky	20352	22.6%
clear	20352	22.6%
is	20352	22.6%
clouds	10643	11.8%
few	4208	4.7%
scattered	3054	3.4%
broken	2888	3.2%
rain	2406	2.7%
light	1802	2.0%
mist	615	0.7%
Other values (14)	3386	3.8%

Most occurring characters

Value	Count	Frequency (%)
s	56576	13.3%
	54994	12.9%
e	36726	8.6%
c	34542	8.1%
l	33186	7.8%
r	31169	7.3%
i	27094	6.4%
a	26983	6.3%
k	23240	5.5%
y	21171	5.0%
Other values (15)	79736	18.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	425417	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	56576	13.3%
	54994	12.9%
e	36726	8.6%
c	34542	8.1%
l	33186	7.8%
r	31169	7.3%
i	27094	6.4%
a	26983	6.3%
k	23240	5.5%
y	21171	5.0%
Other values (15)	79736	18.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	425417	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	56576	13.3%
	54994	12.9%
e	36726	8.6%
c	34542	8.1%
l	33186	7.8%
r	31169	7.3%
i	27094	6.4%
a	26983	6.3%
k	23240	5.5%
y	21171	5.0%
Other values (15)	79736	18.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	425417	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	56576	13.3%
	54994	12.9%
e	36726	8.6%
c	34542	8.1%
l	33186	7.8%
r	31169	7.3%
i	27094	6.4%
a	26983	6.3%
k	23240	5.5%
y	21171	5.0%
Other values (15)	79736	18.7%

weather_icon
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.3 MiB

01n	9437
01d	9131
02d	2458
02n	1653
04n	1576
Other values (18)	10809

Length

Max length	3
Median length	3
Mean length	2.9054586
Min length	2

Characters and Unicode

Total characters	101877
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	01n
2nd row	01n
3rd row	01n
4th row	01n
5th row	01n

Common Values

Value	Count	Frequency (%)
01n	9437	26.9%
01d	9131	26.0%
02d	2458	7.0%
02n	1653	4.7%
04n	1576	4.5%
03d	1524	4.3%
04d	1301	3.7%
01	1268	3.6%
03n	1169	3.3%
10n	722	2.1%
Other values (13)	4825	13.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
01n	9437	26.9%
01d	9131	26.0%
02d	2458	7.0%
02n	1653	4.7%
04n	1576	4.5%
03d	1524	4.3%
04d	1301	3.7%
01	1268	3.6%
03n	1169	3.3%
10n	722	2.1%
Other values (13)	4825	13.8%

Most occurring characters

Value	Count	Frequency (%)
0	34860	34.2%
1	22199	21.8%
d	16286	16.0%
n	15463	15.2%
2	4724	4.6%
4	3381	3.3%
3	3094	3.0%
5	1097	1.1%
9	773	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	101877	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	34860	34.2%
1	22199	21.8%
d	16286	16.0%
n	15463	15.2%
2	4724	4.6%
4	3381	3.3%
3	3094	3.0%
5	1097	1.1%
9	773	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	101877	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	34860	34.2%
1	22199	21.8%
d	16286	16.0%
n	15463	15.2%
2	4724	4.6%
4	3381	3.3%
3	3094	3.0%
5	1097	1.1%
9	773	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	101877	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	34860	34.2%
1	22199	21.8%
d	16286	16.0%
n	15463	15.2%
2	4724	4.6%
4	3381	3.3%
3	3094	3.0%
5	1097	1.1%
9	773	0.8%

Auto

Heatmap
Table

	clouds_all	humidity	pressure	rain_1h	rain_3h	snow_3h	temp	temp_max	temp_min	time	weather_description	weather_icon	weather_id	weather_main	wind_deg	wind_speed
clouds_all	1.000	0.438	-0.280	0.274	0.059	0.051	-0.248	-0.265	-0.238	0.037	0.592	0.578	0.360	0.395	0.038	0.229
humidity	0.438	1.000	0.002	0.181	0.027	0.000	-0.776	-0.782	-0.734	-0.282	0.199	0.240	-0.025	0.190	0.054	-0.162
pressure	-0.280	0.002	1.000	0.178	0.012	0.018	-0.097	-0.073	-0.102	-0.045	0.159	0.172	-0.099	0.145	-0.061	-0.303
rain_1h	0.274	0.181	0.178	1.000	0.000	0.031	0.109	0.110	0.113	0.039	0.962	0.568	0.580	0.558	0.066	0.093
rain_3h	0.059	0.027	0.012	0.000	1.000	0.000	-0.032	-0.039	-0.024	-0.008	0.010	0.078	0.078	0.015	0.001	0.014
snow_3h	0.051	0.000	0.018	0.031	0.000	1.000	0.000	0.000	0.000	0.008	0.029	0.033	0.017	0.013	0.008	0.000
temp	-0.248	-0.776	-0.097	0.109	-0.032	0.000	1.000	0.990	0.973	0.235	0.147	0.198	-0.002	0.138	-0.090	0.126
temp_max	-0.265	-0.782	-0.073	0.110	-0.039	0.000	0.990	1.000	0.941	0.230	0.145	0.206	-0.009	0.135	-0.091	0.112
temp_min	-0.238	-0.734	-0.102	0.113	-0.024	0.000	0.973	0.941	1.000	0.220	0.147	0.189	-0.005	0.139	-0.089	0.115
time	0.037	-0.282	-0.045	0.039	-0.008	0.008	0.235	0.230	0.220	1.000	0.076	0.288	0.025	0.066	0.030	0.183
weather_description	0.592	0.199	0.159	0.962	0.010	0.029	0.147	0.145	0.147	0.076	1.000	0.610	1.000	1.000	0.091	0.128
weather_icon	0.578	0.240	0.172	0.568	0.078	0.033	0.198	0.206	0.189	0.288	0.610	1.000	0.923	0.825	0.133	0.115
weather_id	0.360	-0.025	-0.099	0.580	0.078	0.017	-0.002	-0.009	-0.005	0.025	1.000	0.923	1.000	0.913	0.043	0.106
weather_main	0.395	0.190	0.145	0.558	0.015	0.013	0.138	0.135	0.139	0.066	1.000	0.825	0.913	1.000	0.089	0.107
wind_deg	0.038	0.054	-0.061	0.066	0.001	0.008	-0.090	-0.091	-0.089	0.030	0.091	0.133	0.043	0.089	1.000	0.270
wind_speed	0.229	-0.162	-0.303	0.093	0.014	0.000	0.126	0.112	0.115	0.183	0.128	0.115	0.106	0.107	0.270	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	date	time	temp	temp_min	temp_max	pressure	humidity	wind_speed	wind_deg	weather_id	weather_main	weather_description	weather_icon
35145	2014-12-31	23	267.325	267.325	267.325	971	63	1	309	800	clear	sky is clear	01n
35146	2015-01-01	0	267.325	267.325	267.325	971	63	1	309	800	clear	sky is clear	01n
35147	2015-01-01	1	266.186	266.186	266.186	971	64	1	273	800	clear	sky is clear	01n
35148	2015-01-01	2	266.186	266.186	266.186	971	64	1	273	800	clear	sky is clear	01n
35149	2015-01-01	3	266.186	266.186	266.186	971	64	1	273	800	clear	sky is clear	01n
35150	2015-01-01	4	265.442	265.442	265.442	972	64	0	240	800	clear	sky is clear	01n
35151	2015-01-01	5	265.442	265.442	265.442	972	64	0	240	800	clear	sky is clear	01n
35152	2015-01-01	6	265.442	265.442	265.442	972	64	0	240	800	clear	sky is clear	01n
35153	2015-01-01	7	268.276	268.276	268.276	974	66	1	329	800	clear	sky is clear	01d
35154	2015-01-01	8	268.276	268.276	268.276	974	66	1	329	800	clear	sky is clear	01d

	date	time	temp	temp_min	temp_max	pressure	humidity	wind_speed	wind_deg	weather_id	weather_main	weather_description	weather_icon
71402	2018-12-31	13	285.34	283.15	288.15	1031	24	0	0	800	clear	sky is clear	01d
71403	2018-12-31	14	286.74	285.15	288.15	1030	24	1	0	800	clear	sky is clear	01d
71404	2018-12-31	15	288.12	287.15	289.15	1030	29	1	0	800	clear	sky is clear	01d
71405	2018-12-31	16	288.34	287.15	289.15	1030	26	1	210	800	clear	sky is clear	01d
71406	2018-12-31	17	287.76	286.15	289.15	1030	30	1	190	800	clear	sky is clear	01d
71407	2018-12-31	18	283.56	282.15	285.15	1030	88	1	280	800	clear	sky is clear	01n
71408	2018-12-31	19	280.12	278.15	281.15	1031	52	1	260	800	clear	sky is clear	01n
71409	2018-12-31	20	278.15	278.15	278.15	1030	65	1	340	800	clear	sky is clear	01n
71410	2018-12-31	21	276.57	276.15	277.15	1031	69	2	340	800	clear	sky is clear	01n
71411	2018-12-31	22	275.15	275.15	275.15	1031	74	1	360	800	clear	sky is clear	01n

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample